CREATE TRIGGER [TR_AS_INSERT_MASTER_DATA] ON [dbo].[MMS_MASTER_DATA] 
  AFTER INSERT AS
BEGIN

  SET NOCOUNT ON;
  UPDATE [dbo].[MMS_MASTER_DATA] 
  SET create_date = getdate() 
  WHERE id IN (SELECT TOP 1 id FROM [dbo].[MMS_MASTER_DATA] ORDER BY id DESC)

END

DROP TRIGGER [TR_AS_INSERT_MASTER_DATA];